﻿using Dapper;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using YinfangWeb.BLL.Enum;
using YinfangWeb.BLL.Model;
using YinfangWeb.Model;

namespace YinfangWeb.DAL
{
    public partial class UserRoleDAO
    {
        #region
        /// <summary>
		/// 获取全部记录列表 关键信息
		/// </summary>
		/// <returns>实体列表</returns>
        public List<dynamic> GetListKeyInfo()
        {
            var sql = "SELECT UserRoleID, UserIdentity, RoleName, RoleLevel FROM UserRole order by UserIdentity,UserRoleID";
            using (var conn = ConnectionFactory.CreateConnection())
            {
                var q = conn.Query<dynamic>(sql);
                return q.ToList();
            }
        }
        #endregion
    }
}
